SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019523 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019523 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479335,897795,359018,119899,492124,995024,184140,1037977,203412,28579,603717,258292,887535,967878,445951,53218,782985,584398,404919,485440,207719,289428,689426,41449,713035,1045804,398983,794298,466948,802515,707683,647210,620337,724350,427479,783797,654515,1046225,251778,960233,381877,1035800,441545,598329,570398,851733,291860,94850,513337,617652,922277,475021,577247,643409,111798,684970,304189,570177,113107,914995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]