SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265001 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265001 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984932,914054,728561,620940,910484,709745,511581,706457,93261,664754,887745,470134,483803,476122,551445,912192,1045607,523797,391911,558232,46311,109531,244402,152850,101629,551242,151801,216750,789531,130503,804690,721693,863594,330179,512048,391156,446318,337263,332811,992581,902707,169650,666099,614071,907045,663943,926806,534703,490297,620198,504094,409666,773628,259631,836289,109377,169908,1006827,327487,719039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]