SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331128 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331128 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590574,1043520,694733,289765,448499,803061,769384,635379,883509,275371,494435,765470,179930,927066,300742,44471,314118,186497,467400,98118,915104,65980,144673,680492,45948,363456,84201,246599,238914,416239,1019248,523044,840742,672257,156872,608913,310227,547130,40112,303961,451747,937750,244575,681159,1004922,97041,99755,260527,440608,662584,176044,147661,191174,743957,221336,267899,23544,231139,394672,360466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]