SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408753 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408753 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437553,1044297,417096,489242,990816,995884,814843,709355,942314,210707,355667,387718,921173,136292,764092,447235,739144,463599,890829,284850,829232,939904,377278,22680,235904,858597,456598,938313,742650,236185,942048,847890,935713,668656,316058,801661,404574,342492,56668,245883,930974,440881,639769,332980,969180,195124,61773,453088,178018,1019444,240051,624396,280735,64799,1023608,462719,368761,402251,399611,404390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]