SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 605343 LIMIT 1 [ RunTime:0.000741s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 605343 [ RunTime:0.002721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409497,40930,188753,402002,783405,203539,1000805,180663,483767,767351,817587,856775,280950,375167,635850,480440,561122,759922,839804,561371,75587,624736,593470,705959,728634,58506,1030418,197887,464012,886141,383069,791069,89796,982846,431880,484120,916764,298054,313218,66858,1014949,8313,669591,174800,620932,1040747,837782,12632,831173,610670,566348,231983,244972,389321,164976,447877,66798,176766,26849,978547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 605343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 605343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]