SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388093 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388093 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872289,783075,768121,313099,916653,578428,331223,113443,173807,481493,751881,1029861,319426,1037075,855220,42680,217401,277523,260469,418208,718547,533908,76448,657455,528540,952482,326923,355500,799263,858018,1010871,634578,746128,146955,393379,265195,678599,986240,405922,1013284,998885,233,735135,754129,298545,718867,132938,597388,671380,1014240,490727,206135,885067,297701,560074,468889,799798,376682,725702,531497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000843s ]