SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521438 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521438 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512041,940246,751524,514173,653200,894309,619061,339932,644575,905241,907195,264901,374979,446997,1041723,650963,339238,265500,964009,18789,481599,511603,685664,479452,780227,494199,317824,225659,94785,646184,555251,559070,51757,215386,486178,224286,397269,859735,899340,806385,444193,29178,43683,16669,225955,484532,28150,104623,765140,200336,466795,915464,915186,718868,193922,259140,454360,434655,6040,174545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000762s ]