SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357036 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357036 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944813,40676,148119,390528,370721,444106,943985,99013,282633,650896,295328,236152,53248,183963,900205,359879,503436,970074,888973,369752,90929,289066,726975,815930,314109,1008458,363762,84940,402939,304901,637619,2694,712378,605179,120801,552334,230850,457903,465117,546416,580387,850519,183605,325180,426808,781068,137273,759062,1017566,21069,419737,232168,261196,774832,301355,31359,1032471,442550,348374,525342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]