SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437098 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437098 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794788,992284,31245,764393,23134,126005,967857,743054,1019265,797384,766656,690420,954741,651421,735362,923111,544032,526605,910348,363788,66989,753805,814957,647997,775537,1039432,185484,452887,579586,419987,882838,578389,219796,544781,762750,240665,733401,236528,570525,35663,246144,241331,160754,85223,227869,840194,387279,203043,274050,395999,199897,150544,624337,889787,231218,1014852,774287,693100,126630,864572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]