SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295671 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295671 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783564,512290,520386,824036,859257,803085,119138,567518,1043760,604755,685744,1009963,633680,253240,923517,904846,773217,1029163,30377,103994,770526,967817,427051,609960,488315,127493,506381,1028575,709955,635121,951456,938929,638004,544544,188791,817217,873766,1045631,845452,515830,904425,994978,806788,1028456,245894,857990,24226,337978,323098,272288,394365,768954,902590,565377,117266,558322,973316,505642,848200,9127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]