SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529134 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529134 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714138,714540,453632,1037248,826329,768193,481464,499646,420705,264028,444657,813221,675277,764676,633569,166300,76174,406111,11985,531368,706455,121080,336032,1013032,884120,741155,728924,190348,338735,364118,420394,287330,798125,731125,196196,664969,915816,674941,680016,248412,198321,142339,666635,505070,236722,858525,592479,1025574,434126,475951,680331,155955,224597,444604,108145,213421,595118,906853,439319,976938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]