SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441201 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441201 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406618,4568,275352,679330,720351,749502,853336,1037531,519904,308097,462705,435398,915887,356710,505438,182696,599647,296348,680158,561305,535421,126143,994356,328834,253746,650005,490517,542889,849133,20769,855164,807539,164393,645477,638383,1007826,25014,873173,141285,96188,616113,391787,1044451,413624,817528,8002,499311,571245,653669,552056,450146,83678,548718,894146,683415,166649,877685,353852,299684,324329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]