SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419903 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419903 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426644,990178,865838,912302,134914,323949,918070,478473,711745,837521,650293,631202,64348,87957,666063,929025,244819,48677,422328,955753,334949,159736,373947,939114,1045732,239422,733608,492745,293840,692142,615678,1006672,686186,53588,957063,549616,445761,202047,244099,520600,1031765,454698,921504,480575,603030,966160,651299,401444,116051,464007,611209,899341,761232,973948,682830,553956,441917,481124,431255,404411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]