SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568311 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568311 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855210,38046,188751,522462,66503,1003035,723644,1002769,725925,1021002,433648,672048,961453,390068,203817,422656,728792,863261,716272,46670,112899,577242,509622,404590,218880,452643,943338,666190,985918,520856,694976,608037,982290,469825,1020572,781886,39755,999559,158178,701192,1017587,54106,358532,262979,100004,72212,767257,706941,623273,1006498,595239,434317,279523,399098,599765,238753,484648,437723,388615,201533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001460s ]