SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293201 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293201 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563160,550083,916842,310136,261364,880653,592841,495900,611958,172570,926105,636422,203323,357428,785363,856944,775834,694533,279905,200993,136343,170982,327525,289815,154005,164752,737153,305996,297217,958531,891047,966024,668215,672280,469678,478266,833771,764922,624435,79978,337509,650692,58176,188131,588498,340888,942378,554671,934219,595895,237076,45118,195587,83884,764298,116744,516277,828077,73249,1040949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002904s ]