SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454942 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454942 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914840,456836,734876,205804,879076,650198,397905,405374,1033406,1041406,85408,105518,378717,638231,619737,209750,234645,186035,930366,101830,681586,295762,24349,740487,161038,728373,905201,172305,553219,200143,383457,523464,700038,424147,339974,28480,638631,547207,401890,846344,909402,390479,969259,349696,585923,337355,102386,403819,652572,325687,814639,678741,131116,598169,482909,442915,720167,918540,273259,323515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]