SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 186800 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 186800 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11601,86638,896241,201618,1008383,295502,712167,70446,1030189,101912,1002320,590637,788753,230905,72184,853397,114461,12369,823617,963126,737766,772053,393739,316792,128280,183649,576009,606093,750502,1020459,77039,499957,582802,1028290,953860,61032,976234,406416,614235,372765,408538,472343,705555,881312,673174,64958,544896,299164,579038,846096,168652,781768,910164,241657,571996,1025602,678985,627018,52821,461224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 186800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 186800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]