SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320626 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320626 [ RunTime:0.003286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278176,905172,151510,661873,707595,305123,830629,448818,114695,627077,507069,318397,65506,519317,178410,529375,1045302,100882,784268,232458,542181,254498,997837,962253,329808,861161,151588,729114,622311,773534,130553,966693,740144,790911,274448,367039,91885,611140,444331,98691,818273,1002847,352087,61279,490596,945571,194189,795334,680668,492996,894972,1046919,491131,1027290,533002,701659,177801,131963,408268,326650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]