SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411157 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411157 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572742,419397,231805,629247,524982,118402,262083,447743,581323,437761,344275,885903,787725,801533,720534,357255,852038,395743,693178,11537,542901,442642,863413,675312,261315,393574,1033333,217707,146497,510408,549883,74098,69230,346597,1008353,387744,323221,828082,728359,512030,863286,713640,630282,729479,255467,614905,110323,11873,335729,64309,399988,441297,596081,462361,755945,801686,757675,384280,11965,1007648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]