SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041733 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041733 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954773,199060,207322,1026680,101968,947181,398188,395506,1036935,755601,268845,186832,49796,626365,413001,860683,913934,663398,451473,601165,719668,363630,777008,176188,252237,604393,152582,544833,980616,513473,252573,38205,158619,628857,918322,928268,215957,365564,732713,421431,638703,82524,735159,925444,158383,314682,965756,358736,167912,237014,965296,977152,107210,799367,224522,576660,532088,381087,32989,365777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]