SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398170 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398170 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194605,44001,600929,475203,427938,343691,254287,965740,181101,417569,186436,671673,63898,647533,679326,392494,199724,1045580,98636,709520,625247,967532,252248,710035,653580,440090,569780,225855,486185,312276,34936,101895,190088,495242,608106,500596,732550,981693,319738,570715,638484,19895,869528,289018,299750,556902,1009638,375896,1037844,324568,220571,847369,592888,942104,813479,536689,607998,836941,583708,986864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]