SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101514 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101514 [ RunTime:0.002597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60311,167244,860724,266095,870184,586277,840745,469880,283725,899039,115125,594209,766571,58651,101283,500866,309242,937758,686240,133038,38365,139279,881322,424922,113351,466886,161094,969107,117744,976757,14570,200467,507176,1030211,73687,906199,105623,302585,558950,266839,328301,621549,143529,49912,102739,4892,602390,861383,333508,831240,70957,67753,389785,778670,513044,1011239,312125,414939,905839,309376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]