SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392800 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392800 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471143,452931,983208,173714,788979,332305,71377,111145,605688,964170,231078,30818,780855,397970,77664,328471,850032,406119,408713,737459,155454,750109,273626,255471,352872,57118,251748,138119,924497,3845,486803,751322,622309,165847,102453,911086,182814,671730,242042,806245,793112,216177,787242,376767,290263,347414,596949,682593,2397,972291,214553,229504,775367,563512,294625,26960,987793,967393,54076,295605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]