SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039560 LIMIT 1 [ RunTime:0.001157s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039560 [ RunTime:0.004306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771184,340423,908877,53199,376769,729243,54804,1021151,739439,576212,104100,568607,990728,956065,223901,733967,415063,112853,52109,275943,147144,307207,432526,1005068,493358,1040001,809087,873182,972707,30313,491557,1008920,715301,461131,746092,235852,347262,336021,39459,973722,994907,763973,959815,691866,1012144,620538,689068,432520,18341,15944,677041,252945,659712,980157,545443,892865,273399,189734,97144,296487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001513s ]