SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354412 LIMIT 1 [ RunTime:0.001502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354412 [ RunTime:0.003947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382228,469394,43101,162868,487179,950242,884487,827566,565464,957692,453168,698322,785731,638231,814222,617928,960790,287853,471249,544814,192061,158208,463454,739771,279435,1004553,515621,438698,53233,533223,449355,408103,272920,675161,245382,219080,496735,694402,643654,200576,44906,968952,117980,834236,406624,371787,908997,171514,973340,79690,274696,471920,1020547,102537,608928,774867,440823,98768,331163,420125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]