SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504004 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504004 [ RunTime:0.002842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773248,297772,691642,212730,172119,619771,85018,43240,30569,755701,477510,872036,56219,124560,820578,685158,61594,980573,534852,786636,891114,317767,420915,852614,792997,746465,969201,762507,43756,142866,411727,46773,899100,125040,779689,461406,761254,551320,894616,1151,513103,603835,175153,327133,283446,204246,11180,590585,568232,637795,618375,963145,569916,205326,238518,9595,534123,743556,748753,632932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]