SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438074 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438074 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61029,824841,340432,175054,390541,566774,255618,224327,882159,660421,941747,205502,179485,67260,999841,624718,187950,833297,254167,117011,634005,690420,260332,160845,675600,382592,1028418,722919,877339,172269,128399,89408,333234,203316,137949,369993,543294,791447,592328,451660,735141,656847,165181,654246,746309,999920,41887,1004277,748866,612863,420272,664959,354690,761371,126065,222365,678724,846218,40171,866503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001546s ]