SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102893 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102893 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449974,762047,11148,381435,469977,707605,1028132,44404,263701,572280,888319,417338,109771,705056,892481,573925,288942,258985,134292,896376,1033803,13079,891920,515091,151841,433377,83113,456479,360466,898818,1041781,699491,203613,525551,492645,1006483,67968,295277,372558,372528,216230,558923,545418,36965,875026,17460,641287,618477,803754,201040,791905,584823,21009,974916,1041934,876826,732786,720562,906328,375317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]