SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543073 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543073 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496091,256581,388563,107726,373798,328956,349136,1017787,474667,408987,854590,104972,721807,1001282,474087,43211,548353,224723,435404,1012686,814334,866987,337618,338511,297903,624213,1017751,307274,550996,199106,723756,354685,402597,652278,500895,1013696,293706,736990,445815,758323,152520,421171,92441,75536,27562,723214,890606,271444,416320,201419,262977,193352,173319,464718,290435,75498,484279,255004,734603,911459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]