SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453428 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453428 [ RunTime:0.003343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440461,396482,103042,538690,311348,313414,702199,564589,932691,259850,510451,178672,933741,830671,118092,464891,963013,602408,993288,663433,454765,810983,963970,905985,241947,218164,57025,656741,5384,578241,697028,1012827,661730,783332,269234,573646,775160,279160,475760,126227,372423,211898,462101,940706,524651,107784,869101,676150,70304,677038,759849,221866,627180,1011227,78038,87008,347003,571356,979630,841879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]