SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242910 LIMIT 1 [ RunTime:0.001256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242910 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22535,814439,901310,405958,658408,1009182,627298,552367,180803,323810,261948,198017,812350,4278,207514,662837,749850,338282,1047638,407155,490272,672586,792553,875133,890177,682579,319525,606512,70742,482714,291635,502846,907950,503763,992013,567661,399022,165921,32352,360909,749569,698038,587411,285008,44643,435232,175093,494842,565387,185981,652798,554745,536940,688665,249036,349806,532857,320038,391218,405377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]