SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285914 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285914 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287512,134772,354847,942138,648179,287103,745659,140405,135189,992052,101983,754212,59188,403325,25434,832062,159691,744003,658366,505326,719482,146938,511467,307407,745719,11691,529016,27320,30419,924205,783535,1028401,562816,761220,936077,954607,915291,769404,931617,682067,833699,80505,571283,906320,1013060,585465,569158,128003,121885,193290,411701,874128,559526,809995,329526,739446,643675,986065,494100,982039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]