SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419320 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419320 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953970,294798,634693,582075,529518,426459,154527,200808,880058,507248,194365,331815,753125,957446,222210,383449,226115,441762,304543,963571,96397,572952,489088,1037104,539331,579427,1018741,325130,938226,629072,869159,584437,203244,420226,1007253,256309,884421,516120,545928,419639,848268,357959,845652,87126,904825,273077,285894,986208,586643,988660,403404,469636,639947,573536,925792,111219,274525,356639,650678,134762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]