SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019871 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019871 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306899,1023399,678565,195599,287532,366762,733417,590450,542835,920334,904966,72322,106535,767272,109838,305708,901229,528757,1037214,779598,538802,911733,928861,939296,70955,704038,178410,131456,822264,189406,931344,325966,90261,740375,365746,672252,156826,96236,796190,779847,504245,268069,201699,808747,52514,403516,1022193,497736,847547,961198,151819,633068,776173,471556,714721,355969,857302,793348,453343,830915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]