SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 673851 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 673851 [ RunTime:0.002976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339710,443714,1048478,451010,1014760,26012,243836,88865,911483,448916,33078,858730,288316,211722,985065,530240,41316,165893,288948,872029,887639,460182,59652,1011795,735475,961558,412171,226790,243844,693512,579528,44949,486556,837293,946591,790811,519086,36677,594208,414112,687708,13546,794390,719289,332293,476900,407990,1022289,936394,231241,421923,178853,168066,808910,1020986,201193,279859,624132,283729,354436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 673851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 673851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]