SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283838 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283838 [ RunTime:0.003737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847159,708423,866182,553425,206573,131315,66837,755625,485286,944697,934273,424096,609157,846097,161327,752296,783817,920784,241838,375296,179026,814197,646748,539654,298609,953519,859123,1026937,524720,548532,453645,718367,665485,186623,720374,476021,160152,450145,469413,352485,1044259,714990,579076,616326,678636,916725,358550,964744,668083,780381,1024153,304008,46045,398800,60959,499932,638357,567998,816905,49955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]