SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575628 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575628 [ RunTime:0.003764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369141,424248,657536,352067,171313,499452,294464,128605,669067,84010,770660,212375,757791,345730,48001,639362,768629,79714,677153,495975,432295,34547,752789,544613,749853,676315,252718,551291,967771,137776,372735,1025654,538619,928671,980582,370143,484198,233434,974266,268651,750928,808502,787659,1033692,777189,662007,219486,194198,988810,691151,366648,966248,474422,909736,939100,536675,1008966,462807,311328,870658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]