SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 152613 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 152613 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961901,498879,552970,782004,122829,915416,395754,300041,112015,200803,443754,340712,998183,695654,625323,1006402,987362,580903,357917,470469,10957,132799,253705,942175,1045298,274198,859595,298436,547429,239367,1029353,849244,414713,167845,410522,532086,828093,656942,779305,987772,343384,395686,947365,933738,546831,635961,338759,922240,445198,86292,820170,747953,981790,768193,562955,786432,465763,579542,662422,420275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 152613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 152613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]