SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019835 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019835 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605792,291997,50039,26045,1094,511259,941938,320935,197529,690367,1006087,503590,1048287,199356,68397,606397,511357,105192,87281,1037870,52038,1027260,548086,618328,486179,499961,231607,67827,770021,939399,103218,888129,426592,20812,693603,814356,129126,836909,161740,589595,788581,321381,308135,229920,141991,703577,249566,731244,678761,145614,200907,685186,360894,77948,542546,649328,127843,979547,706986,756530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019835 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019835 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]