SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400025 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400025 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508142,537569,542236,558480,159676,590799,736028,352289,543397,658636,715177,610417,930336,734101,717649,59820,999405,239335,103478,571034,416230,441537,578860,38923,993208,818773,424049,825311,326671,261853,169857,915428,625266,369983,316790,962179,216388,198921,281131,760666,514415,12577,77384,326392,229922,231640,491281,588104,935489,1031,702698,395264,837420,695754,902631,243512,165094,616524,119923,307728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]