SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478212 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478212 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474391,403554,210803,738361,160079,289118,540761,1015305,132942,913639,117867,838377,283398,236603,698663,894411,1025957,529587,376904,561293,442608,226073,226722,478028,591169,930006,423313,592405,663063,1002699,1005830,459997,234570,325501,971844,159992,309413,615646,757497,395633,140512,764316,385330,514149,221357,77235,336622,213133,650588,216466,701377,588035,525083,795773,465631,116742,219714,879180,917477,152607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]