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` = 504975 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504975 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757234,253,589678,143938,202648,453681,944989,733680,153496,685563,1042522,4114,832582,923956,665584,595552,1014344,690761,273013,614618,625280,106362,104351,667802,690130,774575,122280,223792,290190,929955,990580,871512,404436,265713,601033,228115,793119,349701,141646,431037,689801,998348,665262,871577,259316,986605,379390,158566,583016,379883,7342,710356,193394,727163,336318,947128,870648,757883,427109,249048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]