SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047451 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047451 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44951,303840,265551,85530,310699,1006591,139286,277923,432126,602561,291613,525091,546070,586229,60679,545257,431261,629456,434452,178771,726102,959627,39556,218527,534028,443632,173972,762697,828332,205707,937418,835484,29067,224455,266083,656554,589280,937203,216660,807457,550013,287307,350216,661752,352072,728767,292235,694486,541640,318845,568824,486210,83000,308836,176900,735166,1030834,26724,312842,879273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]