SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320628 LIMIT 1 [ RunTime:0.003286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320628 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592042,603722,818609,489663,297992,476477,195489,393120,858751,714994,939699,861317,884794,816810,465476,863496,104263,758226,445645,1034915,888506,814657,905972,917576,1010319,511595,103520,661895,452683,283478,210172,1005036,205567,2136,41110,214828,177011,434569,814029,22695,501206,937420,240658,1035357,171148,479588,312748,405477,261678,1019878,32379,120319,610167,1004136,761073,697267,471665,920307,343743,445781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]