SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204710 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204710 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029988,196318,1004784,882466,322116,834147,805882,774168,764215,283204,293567,115470,893472,211943,1016086,196376,538196,808303,413651,667143,822375,37411,122062,282244,867283,886106,998914,354450,652669,510317,496646,366188,285073,350435,697284,518720,234078,989405,334560,531059,109528,974885,392515,903185,915084,935947,19954,665866,243261,256391,331260,894956,425656,439185,942372,688286,438395,173640,431269,79970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]