SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012966 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012966 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994205,857939,175435,545358,653843,59735,559537,598079,893469,980527,660212,978460,1002660,537246,44871,515048,186348,181842,950363,482040,651092,205849,550850,392571,471485,76690,650084,230196,536260,882873,488204,238100,615544,754920,223882,642071,267885,552135,649954,543927,811952,225805,355644,358181,670984,788595,705033,284774,460482,904800,216968,110226,797325,33713,604949,838763,291328,28039,1048202,708535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]