SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104210 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104210 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797338,991953,465241,8410,574448,720130,3336,704667,878746,331734,862340,34572,15240,577456,434450,930254,1041811,369142,10884,1003470,44282,758364,584205,82488,633552,952500,416357,476280,1026806,760410,24767,516180,137455,1037217,585266,162201,246990,88640,16788,671188,894145,942615,91218,656019,522441,573217,789530,1033645,93541,470574,115590,826410,896132,788670,393375,687794,890201,765414,1033569,970543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]