SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509445 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509445 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264856,1046050,75429,304158,625779,288521,106844,764415,542253,812341,817360,159984,1035907,105899,860987,607114,691055,999832,599527,410781,539416,368264,833087,920646,203508,865583,825466,614043,303161,190723,342977,691870,135700,684669,422318,578504,606371,962653,798188,893475,875435,730598,562144,829576,1033654,285867,424007,190317,815090,914347,108136,251846,1016391,480576,827377,331837,121127,1013217,907579,620570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]