SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405710 LIMIT 1 [ RunTime:0.002518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405710 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851077,621656,234010,112914,1012227,326698,105489,104882,483296,471022,793301,12844,366912,843860,561826,368665,697767,935570,865801,1048795,572703,988751,693349,632937,560396,1021929,2161,755852,643315,166820,549620,540862,269791,58393,513266,461897,948930,600308,1040844,392515,431039,453017,818307,419441,332135,933693,915153,1040943,447366,250584,801241,73592,298819,56280,935435,632803,23306,164409,646225,657713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000924s ]