SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804812 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804812 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494231,793399,787153,131108,849701,114365,246229,105488,260245,100394,104036,648829,947026,8585,960352,486880,692596,558409,257675,1041698,511525,620652,352859,707989,410687,328885,312568,258332,354617,361308,231803,231100,885881,929427,341385,624880,108500,75436,340611,950463,813941,810398,457236,130390,940316,804837,635364,344604,88368,653634,348511,364687,220182,698311,333058,442715,304431,1023247,737682,940262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]