SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529700 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529700 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324898,784419,914764,654078,173949,768734,609005,505837,739220,837504,1022719,558593,1026249,744772,671773,336171,124936,121413,666764,881049,264112,58616,179807,664798,892537,180041,100359,413376,5312,849811,763240,18074,782059,359872,164481,1048842,897136,1040604,578393,750314,771230,531736,503527,941605,32823,337261,286139,606143,645796,1041841,991137,78765,143128,334687,431780,1031214,837623,983429,13488,988066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]