SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332328 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332328 [ RunTime:0.003821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838258,208324,513505,372140,815398,348884,629946,1042249,214652,986652,747806,712729,604235,331650,622992,988179,995296,201496,703431,560641,793394,973955,225929,969079,935941,269911,140029,730837,162682,782492,168101,1004907,150559,572491,396602,1000620,67050,941583,907097,757969,361060,1004250,478840,966603,635419,664904,5454,434065,539354,279223,207709,693085,632996,213505,339185,42668,385386,134568,741434,159948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]