SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033856 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033856 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549942,200605,210422,124227,253628,332742,671450,735436,270146,99094,948040,497127,69037,695227,493308,576540,408024,75350,316404,493632,1042381,682317,448382,729807,833442,975964,529340,32126,857152,571001,61375,451294,1030503,324680,663632,285810,891219,925363,1051,475059,1012670,495724,654772,665020,861325,2252,517436,953124,846723,9464,662059,914028,141076,398881,420828,16528,713264,415495,348331,8035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]