SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419634 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419634 [ RunTime:0.004388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632149,88380,518034,1033859,903164,387452,114500,32280,464380,1028430,707789,484941,2394,835374,800089,666563,411120,904191,832727,388995,329787,796832,658076,437431,583249,971943,502326,165591,918431,227638,256452,295569,147096,1032500,151622,500042,156952,800381,783192,710098,642739,747467,806785,845003,59541,1046924,762935,925049,477270,715638,872752,278749,460554,686577,371402,11913,293678,718729,444663,264867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]