SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441412 LIMIT 1 [ RunTime:0.001653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441412 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034173,816276,981211,471063,817357,351955,798073,546804,860492,294281,797788,476425,1040727,383953,265159,154034,576648,36092,117514,50886,791412,962648,693259,481641,890154,863585,197080,650417,138341,585452,359205,503671,180773,74572,442346,643030,965956,53173,154943,682651,643563,350495,818163,463779,956920,24837,1001732,960726,500107,69280,249563,849289,992476,1045372,568660,289538,127612,980950,586554,734833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001775s ]