SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404593 LIMIT 1 [ RunTime:0.000735s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404593 [ RunTime:0.004534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546035,511530,294430,351421,680024,895893,661567,145190,990973,87868,361302,404956,460684,898700,216827,810272,858625,316652,528058,376909,906868,255057,1027464,229103,562154,153002,453341,612019,53282,68354,787774,430312,484402,266574,27437,807393,1003015,884052,877657,90716,466074,120102,150161,559099,518973,777015,876732,1005778,612896,598126,826133,308006,445345,85083,548208,903386,970670,749404,323853,337867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]