SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961418 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961418 [ RunTime:0.004349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188935,842176,243016,285316,543422,402316,83375,821620,740530,716204,233386,689553,922887,181319,630151,389102,1025108,782312,184844,702392,133795,268520,99563,664801,691301,26199,372439,569818,999785,43790,579045,159037,794443,831873,72157,189377,805874,12785,144976,155242,557626,60338,48354,467475,821830,466905,236196,145035,437309,106650,983087,719588,437464,553086,426790,516778,118658,995774,517392,80787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]