SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508639 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508639 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928298,202772,1022842,496281,456152,92406,87615,262879,497739,830587,949137,110051,1026524,39484,579026,159848,707289,342776,374168,640569,730312,805778,269535,615269,42897,399249,77532,82006,3894,446026,827342,416316,972854,671422,76578,981014,758241,366389,831012,52333,374953,736681,168822,225660,419098,472005,548375,677900,1023488,571744,716631,775472,1016541,555241,734826,467577,21275,669312,534420,736669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]