SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203126 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203126 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841999,5259,639112,524565,160026,796757,813424,191865,935179,336807,897531,233207,361579,614860,710187,894891,1003621,314439,126669,351707,320494,277782,785831,388120,875153,174937,958100,755835,358979,551699,836878,956537,585702,282773,360396,651050,1007545,511401,174166,328604,659949,807700,188719,965003,441479,828216,720569,440265,534410,1047985,784878,196741,371521,857576,209541,956447,599402,1015289,558798,203234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]