SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424438 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424438 [ RunTime:0.003340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489782,988361,846423,204753,825500,182682,40365,121390,393601,819175,252022,541198,235504,313136,26517,3420,473754,252697,215820,589513,1605,824946,875433,115711,1006243,278765,303607,859499,51739,64920,984745,210313,327712,479623,118943,405092,782803,422110,566360,246518,900144,726650,242816,827750,228538,512165,1031629,39183,631752,554277,241162,629985,337509,174015,459121,423025,334988,94331,745752,959101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002312s ]