SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030481 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030481 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523563,88322,101828,768531,496338,640598,928297,12325,369969,942063,846379,60066,495306,590452,636211,130078,937343,697037,88590,216558,608227,586467,158308,641934,303070,621747,550780,444934,739112,801374,918852,148271,127655,325475,73695,373390,821347,810267,642584,947523,302852,626129,307658,845851,834625,810343,428626,755185,3831,387478,714641,735356,718302,263677,316729,354566,580312,392279,975018,237417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]